<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1"><title id="az137232">DROP TEXT SEARCH CONFIGURATION</title><body><p id="sql_command_desc">Removes a text search configuration.</p><section id="section2"><title>Synopsis</title></section>
    <codeblock id="sql_command_synopsis">DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] <varname>name</varname> [ CASCADE | RESTRICT ]</codeblock><section id="section3"><title>Description</title>
      <p>DROP TEXT SEARCH CONFIGURATION drops an existing text search configuration. To run this
        command you must be the owner of the configuration.</p></section><section id="section4"><title>Parameters</title>
      <parml>
        <plentry>
          <pt><codeph>IF EXISTS</codeph></pt>
          <pd>Do not throw an error if the text search configuration does not exist. A notice is
            issued in this case.</pd>
        </plentry>
        <plentry>
          <pt><codeph><varname>name</varname></codeph></pt>
          <pd>The name (optionally schema-qualified) of an existing text search configuration.</pd>
        </plentry>
        <plentry>
          <pt><codeph>CASCADE</codeph></pt>
          <pd>Automatically drop objects that depend on the text search configuration.</pd>
        </plentry>
        <plentry>
          <pt><codeph>RESTRICT</codeph></pt>
          <pd>Refuse to drop the text search configuration if any objects depend on it. This is the
            default.</pd>
        </plentry>
      </parml>
            
            
            
</section><section id="section5"><title>Examples</title>
      <p>Remove the text search configuration my_english:</p>
      <codeblock>DROP TEXT SEARCH CONFIGURATION my_english;</codeblock>
      <p>This command will not succeed if there are any existing indexes that reference the
        configuration in <codeph>to_tsvector</codeph> calls. Add <codeph>CASCADE</codeph> to drop
        such indexes along with the text search configuration.</p></section><section id="section6"><title>Compatibility</title><p>There is no <codeph>DROP TEXT SEARCH CONFIGURATION</codeph> statement in the SQL standard.</p></section><section id="section7"><title>See Also</title><p><codeph><xref href="./ALTER_TEXT_SEARCH_CONFIGURATION.xml" type="topic" format="dita"/></codeph>,
            <codeph><xref href="./CREATE_TEXT_SEARCH_CONFIGURATION.xml" type="topic" format="dita"
          /></codeph></p></section></body></topic>
